﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DinhMuc.Public;

namespace DinhMuc.DAL
{
   public class tblRePortDAL
    {
       clsConnect cn = new clsConnect();
       public DataTable rp_TKSX_thoi(tblReportPublic p)
       {
           int para = 2;
           string[] name = new string[para];
           object[] value = new object[para];
           name[0] = "@tu";
           name[1] = "@den";
           value[0] = p.Tu;
           value[1] = p.Den;
           return cn.LoadTable_loc("sp_report_TKSX_thoi", name, value, para);
       }
       public DataTable rp_TKSX_trangL1(tblReportPublic p)
       {
           int para = 2;
           string[] name = new string[para];
           object[] value = new object[para];
           name[0] = "@tu";
           name[1] = "@den";
           value[0] = p.Tu;
           value[1] = p.Den;
           return cn.LoadTable_loc("sp_report_TKSX_trangL1", name, value, para);
           
       }
       public DataTable rp_TKSX_trangL2(tblReportPublic p)
       {
           int para = 2;
           string[] name = new string[para];
           object[] value = new object[para];
           name[0] = "@tu";
           name[1] = "@den";
           value[0] = p.Tu;
           value[1] = p.Den;
           return cn.LoadTable_loc("sp_report_TKSX_trangL2", name, value, para);
          
       }
       public DataTable rp_TKSX_in(tblReportPublic p)
       {
           int para = 2;
           string[] name = new string[para];
           object[] value = new object[para];
           name[0] = "@tu";
           name[1] = "@den";
           value[0] = p.Tu;
           value[1] = p.Den;
           return cn.LoadTable_loc("sp_report_TKSX_in", name, value, para);
          
       }
       public DataTable rp_TKSX_chiaCuon(tblReportPublic p)
       {
           int para = 2;
           string[] name = new string[para];
           object[] value = new object[para];
           name[0] = "@tu";
           name[1] = "@den";
           value[0] = p.Tu;
           value[1] = p.Den;
           return cn.LoadTable_loc("sp_report_TKSX_chiaCuon", name, value, para);
       }
       public DataTable rp_TKSX_catDan(tblReportPublic p)
       {
           int para = 2;
           string[] name = new string[para];
           object[] value = new object[para];
           name[0] = "@tu";
           name[1] = "@den";
           value[0] = p.Tu;
           value[1] = p.Den;
           return cn.LoadTable_loc("sp_report_TKSX_catDan", name, value, para);
       }
    }
}
